Report email keywords

These keywords can be used for customising the email in either the report SUBJECT or MESSAGE fields. If ANY text is entered into a field, the default text is discarded and the entered data takes it place.

#[SENDER]#

Trading name specified in the system preferences

#[RECORD]#

ID of the record being outputted (e.g. Sales order number)

#[USERID]#

ID of the current user

#[USERNAME]#

Full name of the current user

#[INCLUDE <id>]#

Include the text from search with ID of <id>

#[SQL <query>]#

<query> represents any valid SQL query. #[SQL]# is evaluated last, meaning that other tags included within the #[SQL]# construct will be correctly evaluated and utilised within the SQL query